{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "E:\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:27: FutureWarning: by argument to sort_index is deprecated, please use .sort_values(by=...)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>主评论分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NUM</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2202021011</th>\n",
       "      <td>80.590663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2202021052</th>\n",
       "      <td>80.590663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180105</th>\n",
       "      <td>80.590663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180109</th>\n",
       "      <td>80.590663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180122</th>\n",
       "      <td>80.590663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120070</th>\n",
       "      <td>82.953314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120095</th>\n",
       "      <td>81.771988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120096</th>\n",
       "      <td>80.590663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150053</th>\n",
       "      <td>88.269279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150058</th>\n",
       "      <td>94.766569</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>109 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  主评论分\n",
       "NUM                   \n",
       "2202021011   80.590663\n",
       "2202021052   80.590663\n",
       "20183180105  80.590663\n",
       "20183180109  80.590663\n",
       "20183180122  80.590663\n",
       "...                ...\n",
       "32017120070  82.953314\n",
       "32017120095  81.771988\n",
       "32017120096  80.590663\n",
       "32017150053  88.269279\n",
       "32017150058  94.766569\n",
       "\n",
       "[109 rows x 1 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"\n",
    "作者：陈立仲 22020210042\n",
    "邮箱：510059989@qq.com\n",
    "修改时间：2020.12.22 \n",
    "2020年12月22日 16:23:16\n",
    "\"\"\"\n",
    "\"\"\"\n",
    "主评论区打分\n",
    "\"\"\"\n",
    "import pandas as pd\n",
    "pd.set_option('display.max_rows',10)#显示行部分\n",
    "pd.set_option('display.max_columns',None)#显示列部分\n",
    "data=pd.read_csv('content_main_result.csv',encoding='utf-8')#读取数据集\n",
    "data_dropposition=data.drop(['position'], axis=1)\n",
    "df=data_dropposition.dropna()#删除缺失值\n",
    "#统计评论次数\n",
    "def main_count(l1):\n",
    "    num_count={}\n",
    "    for i in l1:\n",
    "        if i not in num_count:\n",
    "            num_count[i]=1\n",
    "        else:\n",
    "            num_count[i]+=1\n",
    "    return num_count\n",
    "data_main=df[\"Number\"]#提取出学号，方便计算次数\n",
    "times=main_count(data_main)#得出评论次数\n",
    "df = pd.DataFrame(pd.Series(times), columns=['time'])#设为dataframe结构，（这边写繁琐了）\n",
    "df = df.reset_index().rename(columns={'index':'NUM'})#设置索引\n",
    "df.sort_index(by=\"NUM\",axis=0,ascending=True,inplace=True)#按照学号排列\n",
    "df.set_index([\"NUM\"], inplace=True)#设置索引为学号\n",
    "mean=df['time'].mean()#次数平均数\n",
    "def main_score(l1,mean):#打分函数\n",
    "    score1={}\n",
    "    for i in range(len(l1)):\n",
    "        score1=l1/mean*13+80#自己设置的打分函数，次数/平均数*13=80 可以自己写 不一定一样\n",
    "    return score1\n",
    "time_temp=df['time']#提取出次数\n",
    "score2=main_score(time_temp,mean)#带入打分函数 得出结果\n",
    "df['score']=score2#创建新列带入得分 \n",
    "df.loc[df['score']>99]=98#大于99分的都变成98分，不想都是100分\n",
    "final_main=df.drop(['time'],axis = 1,inplace = False) #删除name列final.columns=['time']\n",
    "final_main.columns=['主评论分']#设置索引\n",
    "#pd.options.display.max_rows = None\n",
    "final_main#显示"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "E:\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:2: FutureWarning: by argument to sort_index is deprecated, please use .sort_values(by=...)\n",
      "  \n",
      "E:\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:18: FutureWarning: by argument to sort_index is deprecated, please use .sort_values(by=...)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>123楼评论分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NUM</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2202210028</th>\n",
       "      <td>80.808271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020030091</th>\n",
       "      <td>88.082707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020110133</th>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120004</th>\n",
       "      <td>84.041353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120012</th>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120060</th>\n",
       "      <td>88.082707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210010</th>\n",
       "      <td>80.808271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210015</th>\n",
       "      <td>89.699248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210017</th>\n",
       "      <td>81.616541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210028</th>\n",
       "      <td>86.466165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210029</th>\n",
       "      <td>80.808271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210030</th>\n",
       "      <td>85.657895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210031</th>\n",
       "      <td>80.808271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210035</th>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210036</th>\n",
       "      <td>80.808271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210038</th>\n",
       "      <td>81.616541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210039</th>\n",
       "      <td>80.808271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210042</th>\n",
       "      <td>86.466165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210043</th>\n",
       "      <td>81.616541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210044</th>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210045</th>\n",
       "      <td>97.781955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210048</th>\n",
       "      <td>85.657895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210051</th>\n",
       "      <td>81.616541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210054</th>\n",
       "      <td>84.849624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210055</th>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210084</th>\n",
       "      <td>84.041353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210088</th>\n",
       "      <td>88.082707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210091</th>\n",
       "      <td>83.233083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210096</th>\n",
       "      <td>90.507519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210097</th>\n",
       "      <td>91.315789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210104</th>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210105</th>\n",
       "      <td>84.849624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210109</th>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210110</th>\n",
       "      <td>87.274436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210111</th>\n",
       "      <td>92.124060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210112</th>\n",
       "      <td>81.616541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210113</th>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070008</th>\n",
       "      <td>88.082707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070022</th>\n",
       "      <td>81.616541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070030</th>\n",
       "      <td>88.082707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017110044</th>\n",
       "      <td>95.357143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120048</th>\n",
       "      <td>83.233083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150058</th>\n",
       "      <td>80.808271</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               123楼评论分\n",
       "NUM                   \n",
       "2202210028   80.808271\n",
       "22020030091  88.082707\n",
       "22020110133  98.000000\n",
       "22020120004  84.041353\n",
       "22020120012  98.000000\n",
       "22020120060  88.082707\n",
       "22020210010  80.808271\n",
       "22020210015  89.699248\n",
       "22020210017  81.616541\n",
       "22020210028  86.466165\n",
       "22020210029  80.808271\n",
       "22020210030  85.657895\n",
       "22020210031  80.808271\n",
       "22020210035  98.000000\n",
       "22020210036  80.808271\n",
       "22020210038  81.616541\n",
       "22020210039  80.808271\n",
       "22020210042  86.466165\n",
       "22020210043  81.616541\n",
       "22020210044  98.000000\n",
       "22020210045  97.781955\n",
       "22020210048  85.657895\n",
       "22020210051  81.616541\n",
       "22020210054  84.849624\n",
       "22020210055  98.000000\n",
       "22020210084  84.041353\n",
       "22020210088  88.082707\n",
       "22020210091  83.233083\n",
       "22020210096  90.507519\n",
       "22020210097  91.315789\n",
       "22020210104  98.000000\n",
       "22020210105  84.849624\n",
       "22020210109  98.000000\n",
       "22020210110  87.274436\n",
       "22020210111  92.124060\n",
       "22020210112  81.616541\n",
       "22020210113  98.000000\n",
       "32017070008  88.082707\n",
       "32017070022  81.616541\n",
       "32017070030  88.082707\n",
       "32017110044  95.357143\n",
       "32017120048  83.233083\n",
       "32017150058  80.808271"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"\n",
    "对123楼评论进行分析打分\n",
    "\"\"\"\n",
    "seconddata=pd.read_csv('content_comment_result.csv',encoding='utf-8')#读取数据集\n",
    "seconddata.sort_index(by=\"Number\",axis=0,ascending=True,inplace=True)#按照学号排列\n",
    "data_dropposition=seconddata.drop(['position'], axis=1)#删除位置列\n",
    "#统计评论次数\n",
    "def secondcount(l1):\n",
    "    num_count={}\n",
    "    for i in l1:\n",
    "        if i not in num_count:\n",
    "            num_count[i]=1\n",
    "        else:\n",
    "            num_count[i]+=1\n",
    "    return num_count\n",
    "data_num=data_dropposition[\"Number\"]#提出学号，\n",
    "times=secondcount(data_num)#统计次数\n",
    "sec_df= pd.DataFrame(pd.Series(times), columns=['time'])#设置索引\n",
    "sec_df = sec_df.reset_index().rename(columns={'index':'NUM'})#设置\n",
    "sec_df.sort_index(by=\"NUM\",axis=0,ascending=True,inplace=True)#按照学号排列\n",
    "u = sec_df['time'].mean()  # 计算均值\n",
    "sec_df.set_index([\"NUM\"], inplace=True)#设置索引为学号\n",
    "def sec_score(l1,mean):#打分函数\n",
    "    score1={}\n",
    "    for i in range(len(l1)):\n",
    "        score1=l1/mean*10+80#打分规则  次数/平均*10+80 可以自己定\n",
    "    return score1\n",
    "time_list=sec_df['time']\n",
    "secscore=sec_score(time_list,u)\n",
    "sec_df['123楼评论分']=secscore\n",
    "sec_df.loc[sec_df['123楼评论分']>99]=98\n",
    "final_second=sec_df.drop(['time'],axis = 1,inplace = False) #删除name列。\n",
    "#final_second.columns=['123楼评论分']\n",
    "pd.options.display.max_rows = None\n",
    "final_second"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "score_new = pd.concat([final_main, final_second], axis=1)#连接两个表"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>主评论分</th>\n",
       "      <th>123楼评论分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NUM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2202021011</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2202021052</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180105</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180109</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180122</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180129</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180137</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020030091</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020039991</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020110133</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.993747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120001</th>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120002</th>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120003</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.356815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120004</th>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120006</th>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120009</th>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120010</th>\n",
       "      <td>81.181326</td>\n",
       "      <td>80.908712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120012</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120013</th>\n",
       "      <td>81.771988</td>\n",
       "      <td>81.363068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120016</th>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120018</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120031</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120060</th>\n",
       "      <td>98.901209</td>\n",
       "      <td>94.539391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020120073</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210007</th>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210008</th>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210009</th>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210010</th>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210011</th>\n",
       "      <td>90.631930</td>\n",
       "      <td>88.178408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210012</th>\n",
       "      <td>89.450604</td>\n",
       "      <td>87.269696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210013</th>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210014</th>\n",
       "      <td>91.222593</td>\n",
       "      <td>88.632764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210015</th>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210016</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210017</th>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210018</th>\n",
       "      <td>95.357232</td>\n",
       "      <td>91.813256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210019</th>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210020</th>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210021</th>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210022</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.174239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210023</th>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210025</th>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210026</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.993747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210027</th>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210028</th>\n",
       "      <td>98.310546</td>\n",
       "      <td>94.085035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210029</th>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210030</th>\n",
       "      <td>92.994581</td>\n",
       "      <td>89.995832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210031</th>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210032</th>\n",
       "      <td>86.497291</td>\n",
       "      <td>84.997916</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210033</th>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210035</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.356815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210036</th>\n",
       "      <td>82.362651</td>\n",
       "      <td>81.817424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210037</th>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210038</th>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210039</th>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210040</th>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210041</th>\n",
       "      <td>91.813256</td>\n",
       "      <td>89.087120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210042</th>\n",
       "      <td>95.947895</td>\n",
       "      <td>92.267612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210043</th>\n",
       "      <td>91.813256</td>\n",
       "      <td>89.087120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210044</th>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210045</th>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210046</th>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210047</th>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210048</th>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210049</th>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210050</th>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210051</th>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210052</th>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210054</th>\n",
       "      <td>97.129221</td>\n",
       "      <td>93.176323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210055</th>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210056</th>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210084</th>\n",
       "      <td>95.947895</td>\n",
       "      <td>92.267612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210088</th>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210091</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210092</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210095</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.174239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210096</th>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210097</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210099</th>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210102</th>\n",
       "      <td>98.901209</td>\n",
       "      <td>94.539391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210103</th>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210104</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210105</th>\n",
       "      <td>91.222593</td>\n",
       "      <td>88.632764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210106</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210107</th>\n",
       "      <td>93.585244</td>\n",
       "      <td>90.450188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210109</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210110</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210111</th>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210112</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210113</th>\n",
       "      <td>98.000000</td>\n",
       "      <td>97.265527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020219991</th>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070001</th>\n",
       "      <td>82.362651</td>\n",
       "      <td>81.817424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070008</th>\n",
       "      <td>87.678616</td>\n",
       "      <td>85.906628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070010</th>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070022</th>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070030</th>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070033</th>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070061</th>\n",
       "      <td>83.543977</td>\n",
       "      <td>82.726136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070064</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070079</th>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070086</th>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017070139</th>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017110044</th>\n",
       "      <td>93.585244</td>\n",
       "      <td>90.450188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120048</th>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120070</th>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120095</th>\n",
       "      <td>81.771988</td>\n",
       "      <td>81.363068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120096</th>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150053</th>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150058</th>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  主评论分    123楼评论分\n",
       "NUM                              \n",
       "2202021011   80.590663  80.454356\n",
       "2202021052   80.590663  80.454356\n",
       "20183180105  80.590663  80.454356\n",
       "20183180109  80.590663  80.454356\n",
       "20183180122  80.590663  80.454356\n",
       "20183180129  80.590663  80.454356\n",
       "20183180137  80.590663  80.454356\n",
       "22020030091  98.000000  98.000000\n",
       "22020039991  98.000000  98.000000\n",
       "22020110133  98.000000  94.993747\n",
       "22020120001  97.719883  93.630679\n",
       "22020120002  85.315965  84.089204\n",
       "22020120003  98.000000  96.356815\n",
       "22020120004  84.134639  83.180492\n",
       "22020120006  85.906628  84.543560\n",
       "22020120009  84.725302  83.634848\n",
       "22020120010  81.181326  80.908712\n",
       "22020120012  98.000000  98.000000\n",
       "22020120013  81.771988  81.363068\n",
       "22020120016  82.953314  82.271780\n",
       "22020120018  80.590663  80.454356\n",
       "22020120031  80.590663  80.454356\n",
       "22020120060  98.901209  94.539391\n",
       "22020120073  98.000000  98.000000\n",
       "22020210007  94.766569  91.358900\n",
       "22020210008  88.859942  86.815340\n",
       "22020210009  88.859942  86.815340\n",
       "22020210010  85.315965  84.089204\n",
       "22020210011  90.631930  88.178408\n",
       "22020210012  89.450604  87.269696\n",
       "22020210013  92.403918  89.541476\n",
       "22020210014  91.222593  88.632764\n",
       "22020210015  97.719883  93.630679\n",
       "22020210016  98.000000  98.000000\n",
       "22020210017  97.719883  93.630679\n",
       "22020210018  95.357232  91.813256\n",
       "22020210019  88.859942  86.815340\n",
       "22020210020  87.087953  85.452272\n",
       "22020210021  85.315965  84.089204\n",
       "22020210022  98.000000  98.174239\n",
       "22020210023  85.315965  84.089204\n",
       "22020210025  90.041267  87.724052\n",
       "22020210026  98.000000  94.993747\n",
       "22020210027  90.041267  87.724052\n",
       "22020210028  98.310546  94.085035\n",
       "22020210029  88.269279  86.360984\n",
       "22020210030  92.994581  89.995832\n",
       "22020210031  87.087953  85.452272\n",
       "22020210032  86.497291  84.997916\n",
       "22020210033  87.087953  85.452272\n",
       "22020210035  98.000000  96.356815\n",
       "22020210036  82.362651  81.817424\n",
       "22020210037  87.087953  85.452272\n",
       "22020210038  92.403918  89.541476\n",
       "22020210039  92.403918  89.541476\n",
       "22020210040  82.953314  82.271780\n",
       "22020210041  91.813256  89.087120\n",
       "22020210042  95.947895  92.267612\n",
       "22020210043  91.813256  89.087120\n",
       "22020210044  96.538558  92.721967\n",
       "22020210045  96.538558  92.721967\n",
       "22020210046  82.953314  82.271780\n",
       "22020210047  84.134639  83.180492\n",
       "22020210048  94.175907  90.904544\n",
       "22020210049  87.087953  85.452272\n",
       "22020210050  84.134639  83.180492\n",
       "22020210051  90.041267  87.724052\n",
       "22020210052  88.269279  86.360984\n",
       "22020210054  97.129221  93.176323\n",
       "22020210055  96.538558  92.721967\n",
       "22020210056  87.087953  85.452272\n",
       "22020210084  95.947895  92.267612\n",
       "22020210088  94.766569  91.358900\n",
       "22020210091  98.000000  98.000000\n",
       "22020210092  98.000000  98.000000\n",
       "22020210095  98.000000  98.174239\n",
       "22020210096  92.403918  89.541476\n",
       "22020210097  98.000000  98.000000\n",
       "22020210099  97.719883  93.630679\n",
       "22020210102  98.901209  94.539391\n",
       "22020210103  94.175907  90.904544\n",
       "22020210104  98.000000  98.000000\n",
       "22020210105  91.222593  88.632764\n",
       "22020210106  98.000000  98.000000\n",
       "22020210107  93.585244  90.450188\n",
       "22020210109  98.000000  98.000000\n",
       "22020210110  98.000000  98.000000\n",
       "22020210111  90.041267  87.724052\n",
       "22020210112  98.000000  98.000000\n",
       "22020210113  98.000000  97.265527\n",
       "22020219991  94.175907  90.904544\n",
       "32017070001  82.362651  81.817424\n",
       "32017070008  87.678616  85.906628\n",
       "32017070010  85.906628  84.543560\n",
       "32017070022  84.725302  83.634848\n",
       "32017070030  92.403918  89.541476\n",
       "32017070033  85.906628  84.543560\n",
       "32017070061  83.543977  82.726136\n",
       "32017070064  80.590663  80.454356\n",
       "32017070079  85.906628  84.543560\n",
       "32017070086  84.725302  83.634848\n",
       "32017070139  84.134639  83.180492\n",
       "32017110044  93.585244  90.450188\n",
       "32017120048  85.906628  84.543560\n",
       "32017120070  82.953314  82.271780\n",
       "32017120095  81.771988  81.363068\n",
       "32017120096  80.590663  80.454356\n",
       "32017150053  88.269279  86.360984\n",
       "32017150058  94.766569  91.358900"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "score_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>签到</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Number</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>202002097</th>\n",
       "      <td>91.083846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2202021091</th>\n",
       "      <td>91.083846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3201715005</th>\n",
       "      <td>86.165487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180129</th>\n",
       "      <td>84.878262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020030091</th>\n",
       "      <td>90.996420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120070</th>\n",
       "      <td>95.619231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120095</th>\n",
       "      <td>90.938846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120096</th>\n",
       "      <td>89.728756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150053</th>\n",
       "      <td>88.151613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150058</th>\n",
       "      <td>91.232846</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>110 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    签到\n",
       "Number                \n",
       "202002097    91.083846\n",
       "2202021091   91.083846\n",
       "3201715005   86.165487\n",
       "20183180129  84.878262\n",
       "22020030091  90.996420\n",
       "...                ...\n",
       "32017120070  95.619231\n",
       "32017120095  90.938846\n",
       "32017120096  89.728756\n",
       "32017150053  88.151613\n",
       "32017150058  91.232846\n",
       "\n",
       "[110 rows x 1 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"\n",
    "对签到表的位置和次数进行分析打分\n",
    "\"\"\"\n",
    "import pandas as pd\n",
    "pd.set_option('display.max_rows',10)#显示行部分\n",
    "pd.set_option('display.max_columns',None)#显示列部分\n",
    "third_data=pd.read_csv('content_sign_result.csv',encoding='utf-8')#读取数据集\n",
    "new=third_data.groupby(\"Number\").sum()#对Number进行分组，然后排名\n",
    "#统计签到次数函数\n",
    "def count(l1):\n",
    "    num_count={}\n",
    "    for i in l1:\n",
    "        if i not in num_count:\n",
    "            num_count[i]=1\n",
    "        else:\n",
    "            num_count[i]+=1\n",
    "    return num_count\n",
    "dict1 = third_data['Number']#提取列表\n",
    "dict2=count(dict1)#执行函数\n",
    "#字典转DataFrame格式\n",
    "df3 = pd.DataFrame(pd.Series(dict2), columns=['signcount'])\n",
    "df3 = df3.reset_index().rename(columns={'index':'Number'})\n",
    "df3.set_index([\"Number\"], inplace=True)#将学会设置为索引\n",
    "signcount=df3['signcount']#签到次数列\n",
    "new['signcount']=signcount#将该列写进new的dataframe中， ！==这里写的繁琐了\n",
    "new['meanposition']=new['position']/new['signcount']#获得平均的签到座位号，加入到新列\n",
    "position_mean=new['meanposition'].mean()#所有的签到座位号的平均数\n",
    "score1=position_mean/new['meanposition']*15+75#座位号分数打分\n",
    "new['score1']=score1#加入dataframe中\n",
    "df2=new.copy()#复制该表\n",
    "temp1=df2.drop(['position'],axis=1)#删除position\n",
    "temp2=temp1.drop(['meanposition'],axis=1)#删除meanposition\n",
    "temp3=temp2.drop(['signcount'],axis=1)#删除signcount\n",
    "temp3.loc[temp3['score1']>100]=100#大于100分的都等于100\n",
    "signcount_mean=new['signcount'].mean()#签到次数平均数\n",
    "score2=new['signcount']/signcount_mean*10+85#得分\n",
    "temp3['score2']=score2#添加到temp3表中\n",
    "temp3.loc[temp3['score1']>100]=100#大于100分的都等于100\n",
    "final=(temp3['score2']*0.67)+(temp3['score1']*0.33)#最终得分规则\n",
    "temp3['签到']=final#添加新列\n",
    "sign_total=temp3.drop(['score1'],axis=1).drop(['score2'],axis=1)#删除得分\n",
    "sign_total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学号</th>\n",
       "      <th>主评论分</th>\n",
       "      <th>123楼评论分</th>\n",
       "      <th>签到</th>\n",
       "      <th>总分</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20183180105</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20183180109</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20183180122</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20183180129</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>84.878262</td>\n",
       "      <td>81.836051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20183180137</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>22020030091</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>90.996420</td>\n",
       "      <td>95.898926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>22020039991</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.266924</td>\n",
       "      <td>96.880077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22020110133</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.993747</td>\n",
       "      <td>93.752479</td>\n",
       "      <td>95.823868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>22020120001</td>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "      <td>96.958785</td>\n",
       "      <td>96.264793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>22020120002</td>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "      <td>95.521784</td>\n",
       "      <td>88.009682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>22020120003</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.356815</td>\n",
       "      <td>97.607557</td>\n",
       "      <td>97.389312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>22020120004</td>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "      <td>95.933724</td>\n",
       "      <td>87.388121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>22020120006</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>97.223430</td>\n",
       "      <td>88.892748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>22020120009</td>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "      <td>96.196091</td>\n",
       "      <td>87.839403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>22020120010</td>\n",
       "      <td>81.181326</td>\n",
       "      <td>80.908712</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.745144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>22020120012</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.633369</td>\n",
       "      <td>97.590011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>22020120013</td>\n",
       "      <td>81.771988</td>\n",
       "      <td>81.363068</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>81.117716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22020120016</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>81.862860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>22020120018</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>22020120024</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>91.083846</td>\n",
       "      <td>83.325154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22020120031</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22020120060</td>\n",
       "      <td>98.901209</td>\n",
       "      <td>94.539391</td>\n",
       "      <td>97.410752</td>\n",
       "      <td>97.145526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22020120073</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.407677</td>\n",
       "      <td>97.522303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>22020200015</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>88.830800</td>\n",
       "      <td>82.649240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>22020210007</td>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "      <td>101.140599</td>\n",
       "      <td>95.656477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>22020210008</td>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "      <td>94.775497</td>\n",
       "      <td>90.021228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>22020210009</td>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "      <td>93.260854</td>\n",
       "      <td>89.566835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>22020210010</td>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "      <td>97.044924</td>\n",
       "      <td>88.466624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>22020210011</td>\n",
       "      <td>90.631930</td>\n",
       "      <td>88.178408</td>\n",
       "      <td>88.392550</td>\n",
       "      <td>89.224059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22020210012</td>\n",
       "      <td>89.450604</td>\n",
       "      <td>87.269696</td>\n",
       "      <td>94.785714</td>\n",
       "      <td>90.396865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>22020210013</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>101.288462</td>\n",
       "      <td>94.210548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>22020210014</td>\n",
       "      <td>91.222593</td>\n",
       "      <td>88.632764</td>\n",
       "      <td>93.476436</td>\n",
       "      <td>91.121797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>22020210015</td>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "      <td>94.634384</td>\n",
       "      <td>95.567472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>22020210016</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.798235</td>\n",
       "      <td>97.039471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>22020210017</td>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "      <td>94.756274</td>\n",
       "      <td>95.604039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>22020210018</td>\n",
       "      <td>95.357232</td>\n",
       "      <td>91.813256</td>\n",
       "      <td>94.714989</td>\n",
       "      <td>94.101366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>22020210019</td>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "      <td>97.709745</td>\n",
       "      <td>90.901502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>22020210020</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>96.352905</td>\n",
       "      <td>89.376734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>22020210021</td>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "      <td>92.951029</td>\n",
       "      <td>87.238456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>22020210022</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.174239</td>\n",
       "      <td>94.499445</td>\n",
       "      <td>97.002105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>22020210023</td>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "      <td>93.115819</td>\n",
       "      <td>87.287893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>22020210024</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>90.419306</td>\n",
       "      <td>83.125792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>22020210025</td>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "      <td>94.434580</td>\n",
       "      <td>90.664096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>22020210026</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.993747</td>\n",
       "      <td>92.678856</td>\n",
       "      <td>95.501781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>22020210027</td>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "      <td>93.523837</td>\n",
       "      <td>90.390874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>22020210028</td>\n",
       "      <td>98.310546</td>\n",
       "      <td>94.085035</td>\n",
       "      <td>97.886923</td>\n",
       "      <td>96.915806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>22020210029</td>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "      <td>92.693623</td>\n",
       "      <td>89.024093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>22020210030</td>\n",
       "      <td>92.994581</td>\n",
       "      <td>89.995832</td>\n",
       "      <td>99.400807</td>\n",
       "      <td>94.016824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>22020210031</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>92.664231</td>\n",
       "      <td>88.270132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>22020210032</td>\n",
       "      <td>86.497291</td>\n",
       "      <td>84.997916</td>\n",
       "      <td>97.374809</td>\n",
       "      <td>89.310734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>22020210033</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>100.154615</td>\n",
       "      <td>90.517247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>22020210035</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.356815</td>\n",
       "      <td>97.566075</td>\n",
       "      <td>97.376867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>22020210036</td>\n",
       "      <td>82.362651</td>\n",
       "      <td>81.817424</td>\n",
       "      <td>92.499105</td>\n",
       "      <td>85.240019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>22020210037</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>94.233128</td>\n",
       "      <td>88.740801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>22020210038</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>95.195626</td>\n",
       "      <td>92.382698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>22020210039</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>91.677935</td>\n",
       "      <td>91.327390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>22020210040</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "      <td>92.927059</td>\n",
       "      <td>85.740977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>22020210041</td>\n",
       "      <td>91.813256</td>\n",
       "      <td>89.087120</td>\n",
       "      <td>92.473320</td>\n",
       "      <td>91.193434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>22020210042</td>\n",
       "      <td>95.947895</td>\n",
       "      <td>92.267612</td>\n",
       "      <td>94.973195</td>\n",
       "      <td>94.551400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>22020210043</td>\n",
       "      <td>91.813256</td>\n",
       "      <td>89.087120</td>\n",
       "      <td>94.134638</td>\n",
       "      <td>91.691830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>22020210044</td>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "      <td>94.166996</td>\n",
       "      <td>94.682112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>22020210045</td>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "      <td>95.577302</td>\n",
       "      <td>95.105204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>22020210046</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "      <td>96.143300</td>\n",
       "      <td>86.705849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>22020210047</td>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "      <td>92.849577</td>\n",
       "      <td>86.462876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>22020210048</td>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "      <td>98.995700</td>\n",
       "      <td>94.640436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>22020210049</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>92.723590</td>\n",
       "      <td>88.287940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>22020210050</td>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "      <td>95.873188</td>\n",
       "      <td>87.369960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>22020210051</td>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "      <td>92.933678</td>\n",
       "      <td>90.213826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>22020210052</td>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "      <td>94.371360</td>\n",
       "      <td>89.527415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>22020210054</td>\n",
       "      <td>97.129221</td>\n",
       "      <td>93.176323</td>\n",
       "      <td>98.229527</td>\n",
       "      <td>96.273443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>22020210055</td>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "      <td>98.084682</td>\n",
       "      <td>95.857418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>22020210056</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>95.042556</td>\n",
       "      <td>88.983630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>22020210084</td>\n",
       "      <td>95.947895</td>\n",
       "      <td>92.267612</td>\n",
       "      <td>92.480271</td>\n",
       "      <td>93.803523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>22020210088</td>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "      <td>90.468528</td>\n",
       "      <td>92.454856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>22020210091</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.485385</td>\n",
       "      <td>96.945615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>22020210092</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>97.285769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>22020210095</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.174239</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>97.338041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>22020210096</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>90.278275</td>\n",
       "      <td>90.907492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>22020210097</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>93.351538</td>\n",
       "      <td>96.605462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>22020210099</td>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "      <td>92.422843</td>\n",
       "      <td>94.904010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>22020210102</td>\n",
       "      <td>98.901209</td>\n",
       "      <td>94.539391</td>\n",
       "      <td>92.788165</td>\n",
       "      <td>95.758750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>22020210103</td>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "      <td>92.311775</td>\n",
       "      <td>92.635258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>22020210104</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.958785</td>\n",
       "      <td>97.687635</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>22020210105</td>\n",
       "      <td>91.222593</td>\n",
       "      <td>88.632764</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>91.764635</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>22020210106</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.485385</td>\n",
       "      <td>96.945615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>22020210107</td>\n",
       "      <td>93.585244</td>\n",
       "      <td>90.450188</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>93.254923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>22020210109</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.485385</td>\n",
       "      <td>96.945615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>22020210110</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.753077</td>\n",
       "      <td>97.625923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>22020210111</td>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "      <td>91.771034</td>\n",
       "      <td>89.865033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>22020210112</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.485385</td>\n",
       "      <td>96.945615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>22020210113</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>97.265527</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>97.065427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>22020219991</td>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "      <td>95.705501</td>\n",
       "      <td>93.653376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>32017070001</td>\n",
       "      <td>82.362651</td>\n",
       "      <td>81.817424</td>\n",
       "      <td>86.778764</td>\n",
       "      <td>83.523917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>32017070008</td>\n",
       "      <td>87.678616</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>93.704041</td>\n",
       "      <td>88.954647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>32017070010</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>90.514486</td>\n",
       "      <td>86.880065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>32017070022</td>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "      <td>93.983518</td>\n",
       "      <td>87.175631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>32017070030</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>93.704041</td>\n",
       "      <td>91.935222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>32017070033</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>89.763004</td>\n",
       "      <td>86.654620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>32017070043</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>88.830087</td>\n",
       "      <td>82.649026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>32017070057</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>93.351538</td>\n",
       "      <td>84.005462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>32017070061</td>\n",
       "      <td>83.543977</td>\n",
       "      <td>82.726136</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>86.921201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>32017070064</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>86.046500</td>\n",
       "      <td>82.186522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>32017070079</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>89.869902</td>\n",
       "      <td>86.686690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>32017070086</td>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "      <td>92.991375</td>\n",
       "      <td>86.877988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>32017070090</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>89.906989</td>\n",
       "      <td>82.972097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>32017070096</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>93.431729</td>\n",
       "      <td>84.029519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>32017070097</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>92.660660</td>\n",
       "      <td>83.798198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>32017070139</td>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "      <td>91.822414</td>\n",
       "      <td>86.154728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>32017110044</td>\n",
       "      <td>93.585244</td>\n",
       "      <td>90.450188</td>\n",
       "      <td>91.375630</td>\n",
       "      <td>91.981843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>32017120048</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>91.232846</td>\n",
       "      <td>87.095573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>32017120066</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>84.685769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>32017120070</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>86.548629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>32017120095</td>\n",
       "      <td>81.771988</td>\n",
       "      <td>81.363068</td>\n",
       "      <td>90.938846</td>\n",
       "      <td>84.399369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>32017120096</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>89.728756</td>\n",
       "      <td>83.291199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>32017150053</td>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "      <td>88.151613</td>\n",
       "      <td>87.661491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>32017150058</td>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "      <td>91.232846</td>\n",
       "      <td>92.684151</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              学号       主评论分    123楼评论分          签到         总分\n",
       "0    20183180105  80.590663  80.454356   80.000000  80.372572\n",
       "1    20183180109  80.590663  80.454356   80.000000  80.372572\n",
       "2    20183180122  80.590663  80.454356   80.000000  80.372572\n",
       "3    20183180129  80.590663  80.454356   84.878262  81.836051\n",
       "4    20183180137  80.590663  80.454356   80.000000  80.372572\n",
       "5    22020030091  98.000000  98.000000   90.996420  95.898926\n",
       "6    22020039991  98.000000  98.000000   94.266924  96.880077\n",
       "7    22020110133  98.000000  94.993747   93.752479  95.823868\n",
       "8    22020120001  97.719883  93.630679   96.958785  96.264793\n",
       "9    22020120002  85.315965  84.089204   95.521784  88.009682\n",
       "10   22020120003  98.000000  96.356815   97.607557  97.389312\n",
       "11   22020120004  84.134639  83.180492   95.933724  87.388121\n",
       "12   22020120006  85.906628  84.543560   97.223430  88.892748\n",
       "13   22020120009  84.725302  83.634848   96.196091  87.839403\n",
       "14   22020120010  81.181326  80.908712   80.000000  80.745144\n",
       "15   22020120012  98.000000  98.000000   96.633369  97.590011\n",
       "16   22020120013  81.771988  81.363068   80.000000  81.117716\n",
       "17   22020120016  82.953314  82.271780   80.000000  81.862860\n",
       "18   22020120018  80.590663  80.454356   80.000000  80.372572\n",
       "19   22020120024  80.000000  80.000000   91.083846  83.325154\n",
       "20   22020120031  80.590663  80.454356   80.000000  80.372572\n",
       "21   22020120060  98.901209  94.539391   97.410752  97.145526\n",
       "22   22020120073  98.000000  98.000000   96.407677  97.522303\n",
       "23   22020200015  80.000000  80.000000   88.830800  82.649240\n",
       "24   22020210007  94.766569  91.358900  101.140599  95.656477\n",
       "25   22020210008  88.859942  86.815340   94.775497  90.021228\n",
       "26   22020210009  88.859942  86.815340   93.260854  89.566835\n",
       "27   22020210010  85.315965  84.089204   97.044924  88.466624\n",
       "28   22020210011  90.631930  88.178408   88.392550  89.224059\n",
       "29   22020210012  89.450604  87.269696   94.785714  90.396865\n",
       "30   22020210013  92.403918  89.541476  101.288462  94.210548\n",
       "31   22020210014  91.222593  88.632764   93.476436  91.121797\n",
       "32   22020210015  97.719883  93.630679   94.634384  95.567472\n",
       "33   22020210016  98.000000  98.000000   94.798235  97.039471\n",
       "34   22020210017  97.719883  93.630679   94.756274  95.604039\n",
       "35   22020210018  95.357232  91.813256   94.714989  94.101366\n",
       "36   22020210019  88.859942  86.815340   97.709745  90.901502\n",
       "37   22020210020  87.087953  85.452272   96.352905  89.376734\n",
       "38   22020210021  85.315965  84.089204   92.951029  87.238456\n",
       "39   22020210022  98.000000  98.174239   94.499445  97.002105\n",
       "40   22020210023  85.315965  84.089204   93.115819  87.287893\n",
       "41   22020210024  80.000000  80.000000   90.419306  83.125792\n",
       "42   22020210025  90.041267  87.724052   94.434580  90.664096\n",
       "43   22020210026  98.000000  94.993747   92.678856  95.501781\n",
       "44   22020210027  90.041267  87.724052   93.523837  90.390874\n",
       "45   22020210028  98.310546  94.085035   97.886923  96.915806\n",
       "46   22020210029  88.269279  86.360984   92.693623  89.024093\n",
       "47   22020210030  92.994581  89.995832   99.400807  94.016824\n",
       "48   22020210031  87.087953  85.452272   92.664231  88.270132\n",
       "49   22020210032  86.497291  84.997916   97.374809  89.310734\n",
       "50   22020210033  87.087953  85.452272  100.154615  90.517247\n",
       "51   22020210035  98.000000  96.356815   97.566075  97.376867\n",
       "52   22020210036  82.362651  81.817424   92.499105  85.240019\n",
       "53   22020210037  87.087953  85.452272   94.233128  88.740801\n",
       "54   22020210038  92.403918  89.541476   95.195626  92.382698\n",
       "55   22020210039  92.403918  89.541476   91.677935  91.327390\n",
       "56   22020210040  82.953314  82.271780   92.927059  85.740977\n",
       "57   22020210041  91.813256  89.087120   92.473320  91.193434\n",
       "58   22020210042  95.947895  92.267612   94.973195  94.551400\n",
       "59   22020210043  91.813256  89.087120   94.134638  91.691830\n",
       "60   22020210044  96.538558  92.721967   94.166996  94.682112\n",
       "61   22020210045  96.538558  92.721967   95.577302  95.105204\n",
       "62   22020210046  82.953314  82.271780   96.143300  86.705849\n",
       "63   22020210047  84.134639  83.180492   92.849577  86.462876\n",
       "64   22020210048  94.175907  90.904544   98.995700  94.640436\n",
       "65   22020210049  87.087953  85.452272   92.723590  88.287940\n",
       "66   22020210050  84.134639  83.180492   95.873188  87.369960\n",
       "67   22020210051  90.041267  87.724052   92.933678  90.213826\n",
       "68   22020210052  88.269279  86.360984   94.371360  89.527415\n",
       "69   22020210054  97.129221  93.176323   98.229527  96.273443\n",
       "70   22020210055  96.538558  92.721967   98.084682  95.857418\n",
       "71   22020210056  87.087953  85.452272   95.042556  88.983630\n",
       "72   22020210084  95.947895  92.267612   92.480271  93.803523\n",
       "73   22020210088  94.766569  91.358900   90.468528  92.454856\n",
       "74   22020210091  98.000000  98.000000   94.485385  96.945615\n",
       "75   22020210092  98.000000  98.000000   95.619231  97.285769\n",
       "76   22020210095  98.000000  98.174239   95.619231  97.338041\n",
       "77   22020210096  92.403918  89.541476   90.278275  90.907492\n",
       "78   22020210097  98.000000  98.000000   93.351538  96.605462\n",
       "79   22020210099  97.719883  93.630679   92.422843  94.904010\n",
       "80   22020210102  98.901209  94.539391   92.788165  95.758750\n",
       "81   22020210103  94.175907  90.904544   92.311775  92.635258\n",
       "82   22020210104  98.000000  98.000000   96.958785  97.687635\n",
       "83   22020210105  91.222593  88.632764   95.619231  91.764635\n",
       "84   22020210106  98.000000  98.000000   94.485385  96.945615\n",
       "85   22020210107  93.585244  90.450188   95.619231  93.254923\n",
       "86   22020210109  98.000000  98.000000   94.485385  96.945615\n",
       "87   22020210110  98.000000  98.000000   96.753077  97.625923\n",
       "88   22020210111  90.041267  87.724052   91.771034  89.865033\n",
       "89   22020210112  98.000000  98.000000   94.485385  96.945615\n",
       "90   22020210113  98.000000  97.265527   95.619231  97.065427\n",
       "91   22020219991  94.175907  90.904544   95.705501  93.653376\n",
       "92   32017070001  82.362651  81.817424   86.778764  83.523917\n",
       "93   32017070008  87.678616  85.906628   93.704041  88.954647\n",
       "94   32017070010  85.906628  84.543560   90.514486  86.880065\n",
       "95   32017070022  84.725302  83.634848   93.983518  87.175631\n",
       "96   32017070030  92.403918  89.541476   93.704041  91.935222\n",
       "97   32017070033  85.906628  84.543560   89.763004  86.654620\n",
       "98   32017070043  80.000000  80.000000   88.830087  82.649026\n",
       "99   32017070057  80.000000  80.000000   93.351538  84.005462\n",
       "100  32017070061  83.543977  82.726136   95.619231  86.921201\n",
       "101  32017070064  80.590663  80.454356   86.046500  82.186522\n",
       "102  32017070079  85.906628  84.543560   89.869902  86.686690\n",
       "103  32017070086  84.725302  83.634848   92.991375  86.877988\n",
       "104  32017070090  80.000000  80.000000   89.906989  82.972097\n",
       "105  32017070096  80.000000  80.000000   93.431729  84.029519\n",
       "106  32017070097  80.000000  80.000000   92.660660  83.798198\n",
       "107  32017070139  84.134639  83.180492   91.822414  86.154728\n",
       "108  32017110044  93.585244  90.450188   91.375630  91.981843\n",
       "109  32017120048  85.906628  84.543560   91.232846  87.095573\n",
       "110  32017120066  80.000000  80.000000   95.619231  84.685769\n",
       "111  32017120070  82.953314  82.271780   95.619231  86.548629\n",
       "112  32017120095  81.771988  81.363068   90.938846  84.399369\n",
       "113  32017120096  80.590663  80.454356   89.728756  83.291199\n",
       "114  32017150053  88.269279  86.360984   88.151613  87.661491\n",
       "115  32017150058  94.766569  91.358900   91.232846  92.684151"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"\n",
    "最终结果进行合并处理\n",
    "\"\"\"\n",
    "#pd.options.display.max_rows = None\n",
    "score_final = pd.concat([score_new, sign_total], axis=1)#连接两个表\n",
    "score_final=score_final.fillna(80)\n",
    "score_final.reset_index(inplace=True,drop=False)#重新设置索引 不删除原来的索引\n",
    "score_final=score_final[score_final['index']>=20183180104]#删除无用的学号\n",
    "score_final.reset_index(inplace=True,drop=True)#重新设置索引，删除原来的索引\n",
    "pd.options.display.max_rows = None#展示所有的列\n",
    "score_final[['index']] = score_final[['index']].astype(type)#学号变成文本型\n",
    "totalscore=score_final['主评论分']*0.4+score_final['123楼评论分']*0.3+score_final['签到']*0.3#总分\n",
    "score_final['总分']=totalscore#加入新列\n",
    "score_final=score_final.rename(columns = {\"index\": \"学号\"})#index列名改成学号\n",
    "score_final#最终分数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\"\n",
    "将表写入文件\n",
    "\"\"\"\n",
    "import os\n",
    "import csv\n",
    "if not os.path.exists('score.csv'): \n",
    "    headers = ['Number','main_score','123_score','sign_score','tatal_score'] \n",
    "    with open('score.csv', 'w', newline = '', encoding = 'gbk') as f:  \n",
    "        f_csv = csv.writer(f)  \n",
    "        f_csv.writerow(headers)  \n",
    "with open('score.csv', 'a', newline = '', encoding = 'gbk') as f:\n",
    "    f_csv = csv.writer(f)  \n",
    "    for index,row in score_final.iterrows():\n",
    "        f_csv.writerow(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "E:\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py:3137: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  self[k1] = value[k2]\n",
      "E:\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  after removing the cwd from sys.path.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>主评论分</th>\n",
       "      <th>123楼评论分</th>\n",
       "      <th>签到</th>\n",
       "      <th>总分</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20183180105</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20183180109</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20183180122</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20183180129</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>84.878262</td>\n",
       "      <td>81.836051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20183180137</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>22020030091</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>90.996420</td>\n",
       "      <td>95.898926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>22020039991</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.266924</td>\n",
       "      <td>96.880077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22020110133</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.993747</td>\n",
       "      <td>93.752479</td>\n",
       "      <td>95.823868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>22020120001</td>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "      <td>96.958785</td>\n",
       "      <td>96.264793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>22020120002</td>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "      <td>95.521784</td>\n",
       "      <td>88.009682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>22020120003</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.356815</td>\n",
       "      <td>97.607557</td>\n",
       "      <td>97.389312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>22020120004</td>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "      <td>95.933724</td>\n",
       "      <td>87.388121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>22020120006</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>97.223430</td>\n",
       "      <td>88.892748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>22020120009</td>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "      <td>96.196091</td>\n",
       "      <td>87.839403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>22020120010</td>\n",
       "      <td>81.181326</td>\n",
       "      <td>80.908712</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.745144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>22020120012</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.633369</td>\n",
       "      <td>97.590011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>22020120013</td>\n",
       "      <td>81.771988</td>\n",
       "      <td>81.363068</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>81.117716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22020120016</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>81.862860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>22020120018</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>22020120024</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>91.083846</td>\n",
       "      <td>83.325154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22020120031</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.372572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22020120060</td>\n",
       "      <td>98.901209</td>\n",
       "      <td>94.539391</td>\n",
       "      <td>97.410752</td>\n",
       "      <td>97.145526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22020120073</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.407677</td>\n",
       "      <td>97.522303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>22020200015</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>88.830800</td>\n",
       "      <td>82.649240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>22020210007</td>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "      <td>101.140599</td>\n",
       "      <td>95.656477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>22020210008</td>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "      <td>94.775497</td>\n",
       "      <td>90.021228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>22020210009</td>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "      <td>93.260854</td>\n",
       "      <td>89.566835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>22020210010</td>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "      <td>97.044924</td>\n",
       "      <td>88.466624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>22020210011</td>\n",
       "      <td>90.631930</td>\n",
       "      <td>88.178408</td>\n",
       "      <td>88.392550</td>\n",
       "      <td>89.224059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22020210012</td>\n",
       "      <td>89.450604</td>\n",
       "      <td>87.269696</td>\n",
       "      <td>94.785714</td>\n",
       "      <td>90.396865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>22020210013</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>101.288462</td>\n",
       "      <td>94.210548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>22020210014</td>\n",
       "      <td>91.222593</td>\n",
       "      <td>88.632764</td>\n",
       "      <td>93.476436</td>\n",
       "      <td>91.121797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>22020210015</td>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "      <td>94.634384</td>\n",
       "      <td>95.567472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>22020210016</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.798235</td>\n",
       "      <td>97.039471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>22020210017</td>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "      <td>94.756274</td>\n",
       "      <td>95.604039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>22020210018</td>\n",
       "      <td>95.357232</td>\n",
       "      <td>91.813256</td>\n",
       "      <td>94.714989</td>\n",
       "      <td>94.101366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>22020210019</td>\n",
       "      <td>88.859942</td>\n",
       "      <td>86.815340</td>\n",
       "      <td>97.709745</td>\n",
       "      <td>90.901502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>22020210020</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>96.352905</td>\n",
       "      <td>89.376734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>22020210021</td>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "      <td>92.951029</td>\n",
       "      <td>87.238456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>22020210022</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.174239</td>\n",
       "      <td>94.499445</td>\n",
       "      <td>97.002105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>22020210023</td>\n",
       "      <td>85.315965</td>\n",
       "      <td>84.089204</td>\n",
       "      <td>93.115819</td>\n",
       "      <td>87.287893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>22020210024</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>90.419306</td>\n",
       "      <td>83.125792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>22020210025</td>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "      <td>94.434580</td>\n",
       "      <td>90.664096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>22020210026</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.993747</td>\n",
       "      <td>92.678856</td>\n",
       "      <td>95.501781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>22020210027</td>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "      <td>93.523837</td>\n",
       "      <td>90.390874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>22020210028</td>\n",
       "      <td>98.310546</td>\n",
       "      <td>94.085035</td>\n",
       "      <td>97.886923</td>\n",
       "      <td>96.915806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>22020210029</td>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "      <td>92.693623</td>\n",
       "      <td>89.024093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>22020210030</td>\n",
       "      <td>92.994581</td>\n",
       "      <td>89.995832</td>\n",
       "      <td>99.400807</td>\n",
       "      <td>94.016824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>22020210031</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>92.664231</td>\n",
       "      <td>88.270132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>22020210032</td>\n",
       "      <td>86.497291</td>\n",
       "      <td>84.997916</td>\n",
       "      <td>97.374809</td>\n",
       "      <td>89.310734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>22020210033</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>100.154615</td>\n",
       "      <td>90.517247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>22020210035</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.356815</td>\n",
       "      <td>97.566075</td>\n",
       "      <td>97.376867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>22020210036</td>\n",
       "      <td>82.362651</td>\n",
       "      <td>81.817424</td>\n",
       "      <td>92.499105</td>\n",
       "      <td>85.240019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>22020210037</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>94.233128</td>\n",
       "      <td>88.740801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>22020210038</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>95.195626</td>\n",
       "      <td>92.382698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>22020210039</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>91.677935</td>\n",
       "      <td>91.327390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>22020210040</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "      <td>92.927059</td>\n",
       "      <td>85.740977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>22020210041</td>\n",
       "      <td>91.813256</td>\n",
       "      <td>89.087120</td>\n",
       "      <td>92.473320</td>\n",
       "      <td>91.193434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>22020210042</td>\n",
       "      <td>95.947895</td>\n",
       "      <td>92.267612</td>\n",
       "      <td>94.973195</td>\n",
       "      <td>94.551400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>22020210043</td>\n",
       "      <td>91.813256</td>\n",
       "      <td>89.087120</td>\n",
       "      <td>94.134638</td>\n",
       "      <td>91.691830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>22020210044</td>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "      <td>94.166996</td>\n",
       "      <td>94.682112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>22020210045</td>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "      <td>95.577302</td>\n",
       "      <td>95.105204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>22020210046</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "      <td>96.143300</td>\n",
       "      <td>86.705849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>22020210047</td>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "      <td>92.849577</td>\n",
       "      <td>86.462876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>22020210048</td>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "      <td>98.995700</td>\n",
       "      <td>94.640436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>22020210049</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>92.723590</td>\n",
       "      <td>88.287940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>22020210050</td>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "      <td>95.873188</td>\n",
       "      <td>87.369960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>22020210051</td>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "      <td>92.933678</td>\n",
       "      <td>90.213826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>22020210052</td>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "      <td>94.371360</td>\n",
       "      <td>89.527415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>22020210054</td>\n",
       "      <td>97.129221</td>\n",
       "      <td>93.176323</td>\n",
       "      <td>98.229527</td>\n",
       "      <td>96.273443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>22020210055</td>\n",
       "      <td>96.538558</td>\n",
       "      <td>92.721967</td>\n",
       "      <td>98.084682</td>\n",
       "      <td>95.857418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>22020210056</td>\n",
       "      <td>87.087953</td>\n",
       "      <td>85.452272</td>\n",
       "      <td>95.042556</td>\n",
       "      <td>88.983630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>22020210084</td>\n",
       "      <td>95.947895</td>\n",
       "      <td>92.267612</td>\n",
       "      <td>92.480271</td>\n",
       "      <td>93.803523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>22020210088</td>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "      <td>90.468528</td>\n",
       "      <td>92.454856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>22020210091</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.485385</td>\n",
       "      <td>96.945615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>22020210092</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>97.285769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>22020210095</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.174239</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>97.338041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>22020210096</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>90.278275</td>\n",
       "      <td>90.907492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>22020210097</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>93.351538</td>\n",
       "      <td>96.605462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>22020210099</td>\n",
       "      <td>97.719883</td>\n",
       "      <td>93.630679</td>\n",
       "      <td>92.422843</td>\n",
       "      <td>94.904010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>22020210102</td>\n",
       "      <td>98.901209</td>\n",
       "      <td>94.539391</td>\n",
       "      <td>92.788165</td>\n",
       "      <td>95.758750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>22020210103</td>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "      <td>92.311775</td>\n",
       "      <td>92.635258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>22020210104</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.958785</td>\n",
       "      <td>97.687635</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>22020210105</td>\n",
       "      <td>91.222593</td>\n",
       "      <td>88.632764</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>91.764635</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>22020210106</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.485385</td>\n",
       "      <td>96.945615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>22020210107</td>\n",
       "      <td>93.585244</td>\n",
       "      <td>90.450188</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>93.254923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>22020210109</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.485385</td>\n",
       "      <td>96.945615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>22020210110</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>96.753077</td>\n",
       "      <td>97.625923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>22020210111</td>\n",
       "      <td>90.041267</td>\n",
       "      <td>87.724052</td>\n",
       "      <td>91.771034</td>\n",
       "      <td>89.865033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>22020210112</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>94.485385</td>\n",
       "      <td>96.945615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>22020210113</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>97.265527</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>97.065427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>22020219991</td>\n",
       "      <td>94.175907</td>\n",
       "      <td>90.904544</td>\n",
       "      <td>95.705501</td>\n",
       "      <td>93.653376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>32017070001</td>\n",
       "      <td>82.362651</td>\n",
       "      <td>81.817424</td>\n",
       "      <td>86.778764</td>\n",
       "      <td>83.523917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>32017070008</td>\n",
       "      <td>87.678616</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>93.704041</td>\n",
       "      <td>88.954647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>32017070010</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>90.514486</td>\n",
       "      <td>86.880065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>32017070022</td>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "      <td>93.983518</td>\n",
       "      <td>87.175631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>32017070030</td>\n",
       "      <td>92.403918</td>\n",
       "      <td>89.541476</td>\n",
       "      <td>93.704041</td>\n",
       "      <td>91.935222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>32017070033</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>89.763004</td>\n",
       "      <td>86.654620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>32017070043</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>88.830087</td>\n",
       "      <td>82.649026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>32017070057</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>93.351538</td>\n",
       "      <td>84.005462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>32017070061</td>\n",
       "      <td>83.543977</td>\n",
       "      <td>82.726136</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>86.921201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>32017070064</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>86.046500</td>\n",
       "      <td>82.186522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>32017070079</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>89.869902</td>\n",
       "      <td>86.686690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>32017070086</td>\n",
       "      <td>84.725302</td>\n",
       "      <td>83.634848</td>\n",
       "      <td>92.991375</td>\n",
       "      <td>86.877988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>32017070090</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>89.906989</td>\n",
       "      <td>82.972097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>32017070096</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>93.431729</td>\n",
       "      <td>84.029519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>32017070097</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>92.660660</td>\n",
       "      <td>83.798198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>32017070139</td>\n",
       "      <td>84.134639</td>\n",
       "      <td>83.180492</td>\n",
       "      <td>91.822414</td>\n",
       "      <td>86.154728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>32017110044</td>\n",
       "      <td>93.585244</td>\n",
       "      <td>90.450188</td>\n",
       "      <td>91.375630</td>\n",
       "      <td>91.981843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>32017120048</td>\n",
       "      <td>85.906628</td>\n",
       "      <td>84.543560</td>\n",
       "      <td>91.232846</td>\n",
       "      <td>87.095573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>32017120066</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>84.685769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>32017120070</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>82.271780</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>86.548629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>32017120095</td>\n",
       "      <td>81.771988</td>\n",
       "      <td>81.363068</td>\n",
       "      <td>90.938846</td>\n",
       "      <td>84.399369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>32017120096</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.454356</td>\n",
       "      <td>89.728756</td>\n",
       "      <td>83.291199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>32017150053</td>\n",
       "      <td>88.269279</td>\n",
       "      <td>86.360984</td>\n",
       "      <td>88.151613</td>\n",
       "      <td>87.661491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>32017150058</td>\n",
       "      <td>94.766569</td>\n",
       "      <td>91.358900</td>\n",
       "      <td>91.232846</td>\n",
       "      <td>92.684151</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           index       主评论分    123楼评论分          签到         总分\n",
       "0    20183180105  80.590663  80.454356   80.000000  80.372572\n",
       "1    20183180109  80.590663  80.454356   80.000000  80.372572\n",
       "2    20183180122  80.590663  80.454356   80.000000  80.372572\n",
       "3    20183180129  80.590663  80.454356   84.878262  81.836051\n",
       "4    20183180137  80.590663  80.454356   80.000000  80.372572\n",
       "5    22020030091  98.000000  98.000000   90.996420  95.898926\n",
       "6    22020039991  98.000000  98.000000   94.266924  96.880077\n",
       "7    22020110133  98.000000  94.993747   93.752479  95.823868\n",
       "8    22020120001  97.719883  93.630679   96.958785  96.264793\n",
       "9    22020120002  85.315965  84.089204   95.521784  88.009682\n",
       "10   22020120003  98.000000  96.356815   97.607557  97.389312\n",
       "11   22020120004  84.134639  83.180492   95.933724  87.388121\n",
       "12   22020120006  85.906628  84.543560   97.223430  88.892748\n",
       "13   22020120009  84.725302  83.634848   96.196091  87.839403\n",
       "14   22020120010  81.181326  80.908712   80.000000  80.745144\n",
       "15   22020120012  98.000000  98.000000   96.633369  97.590011\n",
       "16   22020120013  81.771988  81.363068   80.000000  81.117716\n",
       "17   22020120016  82.953314  82.271780   80.000000  81.862860\n",
       "18   22020120018  80.590663  80.454356   80.000000  80.372572\n",
       "19   22020120024  80.000000  80.000000   91.083846  83.325154\n",
       "20   22020120031  80.590663  80.454356   80.000000  80.372572\n",
       "21   22020120060  98.901209  94.539391   97.410752  97.145526\n",
       "22   22020120073  98.000000  98.000000   96.407677  97.522303\n",
       "23   22020200015  80.000000  80.000000   88.830800  82.649240\n",
       "24   22020210007  94.766569  91.358900  101.140599  95.656477\n",
       "25   22020210008  88.859942  86.815340   94.775497  90.021228\n",
       "26   22020210009  88.859942  86.815340   93.260854  89.566835\n",
       "27   22020210010  85.315965  84.089204   97.044924  88.466624\n",
       "28   22020210011  90.631930  88.178408   88.392550  89.224059\n",
       "29   22020210012  89.450604  87.269696   94.785714  90.396865\n",
       "30   22020210013  92.403918  89.541476  101.288462  94.210548\n",
       "31   22020210014  91.222593  88.632764   93.476436  91.121797\n",
       "32   22020210015  97.719883  93.630679   94.634384  95.567472\n",
       "33   22020210016  98.000000  98.000000   94.798235  97.039471\n",
       "34   22020210017  97.719883  93.630679   94.756274  95.604039\n",
       "35   22020210018  95.357232  91.813256   94.714989  94.101366\n",
       "36   22020210019  88.859942  86.815340   97.709745  90.901502\n",
       "37   22020210020  87.087953  85.452272   96.352905  89.376734\n",
       "38   22020210021  85.315965  84.089204   92.951029  87.238456\n",
       "39   22020210022  98.000000  98.174239   94.499445  97.002105\n",
       "40   22020210023  85.315965  84.089204   93.115819  87.287893\n",
       "41   22020210024  80.000000  80.000000   90.419306  83.125792\n",
       "42   22020210025  90.041267  87.724052   94.434580  90.664096\n",
       "43   22020210026  98.000000  94.993747   92.678856  95.501781\n",
       "44   22020210027  90.041267  87.724052   93.523837  90.390874\n",
       "45   22020210028  98.310546  94.085035   97.886923  96.915806\n",
       "46   22020210029  88.269279  86.360984   92.693623  89.024093\n",
       "47   22020210030  92.994581  89.995832   99.400807  94.016824\n",
       "48   22020210031  87.087953  85.452272   92.664231  88.270132\n",
       "49   22020210032  86.497291  84.997916   97.374809  89.310734\n",
       "50   22020210033  87.087953  85.452272  100.154615  90.517247\n",
       "51   22020210035  98.000000  96.356815   97.566075  97.376867\n",
       "52   22020210036  82.362651  81.817424   92.499105  85.240019\n",
       "53   22020210037  87.087953  85.452272   94.233128  88.740801\n",
       "54   22020210038  92.403918  89.541476   95.195626  92.382698\n",
       "55   22020210039  92.403918  89.541476   91.677935  91.327390\n",
       "56   22020210040  82.953314  82.271780   92.927059  85.740977\n",
       "57   22020210041  91.813256  89.087120   92.473320  91.193434\n",
       "58   22020210042  95.947895  92.267612   94.973195  94.551400\n",
       "59   22020210043  91.813256  89.087120   94.134638  91.691830\n",
       "60   22020210044  96.538558  92.721967   94.166996  94.682112\n",
       "61   22020210045  96.538558  92.721967   95.577302  95.105204\n",
       "62   22020210046  82.953314  82.271780   96.143300  86.705849\n",
       "63   22020210047  84.134639  83.180492   92.849577  86.462876\n",
       "64   22020210048  94.175907  90.904544   98.995700  94.640436\n",
       "65   22020210049  87.087953  85.452272   92.723590  88.287940\n",
       "66   22020210050  84.134639  83.180492   95.873188  87.369960\n",
       "67   22020210051  90.041267  87.724052   92.933678  90.213826\n",
       "68   22020210052  88.269279  86.360984   94.371360  89.527415\n",
       "69   22020210054  97.129221  93.176323   98.229527  96.273443\n",
       "70   22020210055  96.538558  92.721967   98.084682  95.857418\n",
       "71   22020210056  87.087953  85.452272   95.042556  88.983630\n",
       "72   22020210084  95.947895  92.267612   92.480271  93.803523\n",
       "73   22020210088  94.766569  91.358900   90.468528  92.454856\n",
       "74   22020210091  98.000000  98.000000   94.485385  96.945615\n",
       "75   22020210092  98.000000  98.000000   95.619231  97.285769\n",
       "76   22020210095  98.000000  98.174239   95.619231  97.338041\n",
       "77   22020210096  92.403918  89.541476   90.278275  90.907492\n",
       "78   22020210097  98.000000  98.000000   93.351538  96.605462\n",
       "79   22020210099  97.719883  93.630679   92.422843  94.904010\n",
       "80   22020210102  98.901209  94.539391   92.788165  95.758750\n",
       "81   22020210103  94.175907  90.904544   92.311775  92.635258\n",
       "82   22020210104  98.000000  98.000000   96.958785  97.687635\n",
       "83   22020210105  91.222593  88.632764   95.619231  91.764635\n",
       "84   22020210106  98.000000  98.000000   94.485385  96.945615\n",
       "85   22020210107  93.585244  90.450188   95.619231  93.254923\n",
       "86   22020210109  98.000000  98.000000   94.485385  96.945615\n",
       "87   22020210110  98.000000  98.000000   96.753077  97.625923\n",
       "88   22020210111  90.041267  87.724052   91.771034  89.865033\n",
       "89   22020210112  98.000000  98.000000   94.485385  96.945615\n",
       "90   22020210113  98.000000  97.265527   95.619231  97.065427\n",
       "91   22020219991  94.175907  90.904544   95.705501  93.653376\n",
       "92   32017070001  82.362651  81.817424   86.778764  83.523917\n",
       "93   32017070008  87.678616  85.906628   93.704041  88.954647\n",
       "94   32017070010  85.906628  84.543560   90.514486  86.880065\n",
       "95   32017070022  84.725302  83.634848   93.983518  87.175631\n",
       "96   32017070030  92.403918  89.541476   93.704041  91.935222\n",
       "97   32017070033  85.906628  84.543560   89.763004  86.654620\n",
       "98   32017070043  80.000000  80.000000   88.830087  82.649026\n",
       "99   32017070057  80.000000  80.000000   93.351538  84.005462\n",
       "100  32017070061  83.543977  82.726136   95.619231  86.921201\n",
       "101  32017070064  80.590663  80.454356   86.046500  82.186522\n",
       "102  32017070079  85.906628  84.543560   89.869902  86.686690\n",
       "103  32017070086  84.725302  83.634848   92.991375  86.877988\n",
       "104  32017070090  80.000000  80.000000   89.906989  82.972097\n",
       "105  32017070096  80.000000  80.000000   93.431729  84.029519\n",
       "106  32017070097  80.000000  80.000000   92.660660  83.798198\n",
       "107  32017070139  84.134639  83.180492   91.822414  86.154728\n",
       "108  32017110044  93.585244  90.450188   91.375630  91.981843\n",
       "109  32017120048  85.906628  84.543560   91.232846  87.095573\n",
       "110  32017120066  80.000000  80.000000   95.619231  84.685769\n",
       "111  32017120070  82.953314  82.271780   95.619231  86.548629\n",
       "112  32017120095  81.771988  81.363068   90.938846  84.399369\n",
       "113  32017120096  80.590663  80.454356   89.728756  83.291199\n",
       "114  32017150053  88.269279  86.360984   88.151613  87.661491\n",
       "115  32017150058  94.766569  91.358900   91.232846  92.684151"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
